﻿CREATE TABLE [dbo].[ToolNote] (
    [NoteID]    INT           IDENTITY (1, 1) NOT NULL,
    [ToolID]    INT           NOT NULL,
    [Note]      VARCHAR (MAX) NULL,
    [AddedBy]   VARCHAR (50)  NULL,
    [AddedDate] DATETIME      NULL,
    CONSTRAINT [PK2] PRIMARY KEY NONCLUSTERED ([NoteID] ASC),
    CONSTRAINT [RefTool2] FOREIGN KEY ([ToolID]) REFERENCES [dbo].[Tool] ([ToolID])
);

